{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example","Sample NCM Compliance Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Example","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[6,0,6,2],[6,3,6,5],[8,1,8,5],[8,6,8,7],[8,9,8,10],[5,0,5,2],[5,3,5,5],[1,0,1,10],[3,0,3,2],[3,3,3,5],[4,0,4,2],[4,3,4,5]]}
[]
["Figure 1: NCM Compliance Schedule"]
[]
["Company name",null,null,"Firm X"]
["Date prepared",null,null,"2012-05-15"]
["For costs incurred during fiscal year ended",null,null,"2011-12-31"]
["Gross revenue from engineering consulting services",null,null,8250000,null,null,"(revenue applicable to general engineering, and related, services)"]
[]
["(Steps 1 & 2)","(Step 1)",null,null,null,null,"(Step 3)",null,"(Step 4)","(Step 5)"]
[]
["Position \n(Match to NCM \nJob Descriptions)","Salary","Bonus","Deferred Compensation","Other Compensation","Total Compensation"," Adjustment for Unallowable Activities & Unallowable Forms of Compensation","Compensation Subject to Reasonable-ness Test","NCM Amount","Adjustment: Amount in Excess of NCM","Total Required Adjustment"]
["Chief Executive Officer",255000,55000,32000,23000,{"$f":"SUM(B12:E12)","v":365000},-18500,{"$f":"SUM(F12:G12)","v":346500},343720.81560807145,{"$f":"IF(H12>I12,I12-H12,0)","v":-2779.1843919285457},{"$f":"J12+G12","v":-21279.184391928546}]
["Chief Financial Officer",204000,22000,18000,28000,272000,-17500,254500,200695.20852977835,-53804.791470221651,-71304.791470221651]
["Senior Vice President",195840,29376,17000,2584,244800,-10500,234300,227273.21974563019,-7026.7802543698053,-17526.780254369805]
["Vice President",146250,35100,12000,1650,195000,-7100,187900,197339.95982781769,0,-7100]
["Vice President",146250,38500,9000,1250,195000,-7100,187900,197339.95982781769,0,-7100]
["Human Resource Director",165000,8000,10000,5000,188000,-8500,179500,120462.53421539534,-59037.465784604661,-67537.465784604661]
["  TOTALS",{"$f":"SUM(B12:B17)","v":1112340},187976,98000,61484,1459800,-69200,1390600,1286831.6977545107,-122648.22190112466,-191848.22190112466]
[]
[]
["I hereby certify that, to the best of my knowledge, this schedule is complete and accurate:"]
[]
[]
[]
[]
[null,"Name and Title (printed or typed)"]
[]
[]
[]
[]
[]
[null,"Signature"]
[]
[]
[]
[]
[null,"Date"]
[]
["(Note: This schedule should be certified by a Company officer/executive.)"]

{"sheet":"Sample NCM Compliance Form","index":1,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[12,0,12,7],[12,8,12,10],[8,0,8,15],[10,0,10,7],[10,8,10,10],[11,0,11,7],[11,8,11,10],[13,0,13,7],[13,8,13,10],[15,6,15,10],[15,11,15,12],[15,14,15,15]]}
[]
[]
[]
[]
[]
[]
["All executives must be listed. This worksheet has space available for 15 executive positions. Additional positions may be added by clicking here: "]
[]
["Sample NCM Compliance Schedule"]
[]
["Company name"]
["Date prepared"]
["For costs incurred during fiscal year ended"]
["Gross revenue from engineering, and related, services"]
[]
["(Steps 1 & 2)",null,null,null,null,null,"(Step 1)",null,null,null,null,"(Step 3)",null,"(Step 4)","(Step 5)"]
[]
["Position \n(Match to NCM \nJob Descriptions)",null,"Name or Employee ID Number",null,"Related Party?\n(y/n)",null,"Salary","Bonus","Deferred Compensation","Other Compensation","Total Compensation"," Adjustment for Unallowable Activities & Unallowable Forms of Compensation","Compensation Subject to Reasonable-ness Test","NCM Amount\n(use numbers from NCM Tool)","Adjustment: Amount in Excess of NCM","Total Required Adjustment"]
[null,null,null,null,null,null,0,0,0,0,{"$f":"SUM(G19:J19)","v":0},0,{"$f":"SUM(K19:L19)","v":0},0,{"$f":"IF(M19>N19,N19-M19,0)","v":0},{"$f":"O19+L19","v":0}]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"O20+L20","v":0}]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,{"$f":"SUM(G22:J22)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,{"$f":"SUM(G28:J28)","v":0},0,{"$f":"SUM(K28:L28)","v":0},0,{"$f":"IF(M28>N28,N28-M28,0)","v":0},0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["  TOTALS",null,null,null,null,null,{"$f":"SUM(G19:G33)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["I hereby certify that, to the best of my knowledge, this schedule is complete and accurate:"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Name and Title (printed or typed)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Date"]
[]
["(Note: This schedule should be certified by a Company officer/executive.)"]